revDatabaseCursors
Type
function
Summary
Returns the record set IDs associated with a connection to a database.
Syntax
revDatabaseCursors(<databaseID>)
Description
Use the revDatabaseCursors function to perform an operation on each record set, or to find out how many record sets exist on a particular database connection.
The record set IDs returned are those opened by the specified databaseID.
The revDatabaseCursors function is part of the Database library. To ensure that the function works in a standalone application, you must include this custom library when you create your standalone. In the Inclusions pane of the Standalone Application Settings window, make sure both the "Database" library checkbox and those of the database drivers you are using are checked.
Parameters
| Name | Type | Description |
|---|---|---|
databaseID | The number returned by the revOpenDatabase function when the database was opened. |
Examples
revDatabaseCursors(weeklyReportsDB)
put the number of items of revDatabaseCursors(2) into numberOfSets
repeat for each item thisResultSet in revDatabaseCursors(myDB)
Related
command: revCloseCursor
control structure: function
glossary: Standalone Application Settings, database, standalone application, record set, return, LiveCode custom library
library: Database library
Compatibility and Support
Introduced
LiveCode 1.1
OS
mac
windows
linux
ios
android
Platforms
desktop
server
mobile